﻿create procedure dbo.GetMenu
(
		@MenuID int
	)
AS
	SET NOCOUNT ON 
	
	
	SELECT     dbo.Menus.Name, dbo.Menus.Address, dbo.Menus.City, dbo.Menus.State, dbo.Menus.Zipcode, dbo.Menus.TaxRate, dbo.MenuItems.Description, 
	                      dbo.MenuItems.Price, dbo.MenuItems.PrepTimeMinutes, dbo.MenuItems.Id AS MenuItemID, dbo.Menus.Id AS MenusID
	FROM         dbo.Menus INNER JOIN
	                      dbo.MenuItems ON dbo.Menus.Id = dbo.MenuItems.MenusId
	RETURN


